SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateAvailableField]
    (
      @JOL_Field_No INT,
      @JOL_Field_Name VARCHAR(50),
      @JOL_Field_Campus VARCHAR(50),
      @JOL_Field_SeatNumber INT,
      @JOL_Field_Money MONEY,
      @JOL_Field_IsProvideMultimedia BIT,
      @JOL_Field_Remark NTEXT,
      @JOL_Field_UpdateTime DATETIME,
      @JOL_Field_UpdateUser VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_AvailableField
    SET     JOL_Field_Name = @JOL_Field_Name,
            JOL_Field_Campus = @JOL_Field_Campus,
            JOL_Field_SeatNumber = @JOL_Field_SeatNumber,
            JOL_Field_Money = @JOL_Field_Money,
            JOL_Field_IsProvideMultimedia = @JOL_Field_IsProvideMultimedia,
            JOL_Field_Remark = @JOL_Field_Remark,
            JOL_Field_UpdateTime = GETDATE(),
            JOL_Field_UpdateUser = @JOL_Field_UpdateUser
    WHERE   JOL_Field_No = @JOL_Field_No
GO
